ocr: Method Best-Case Blocks Read Worst-Case Blocks Read Marked as Least Recently Used Blocks Heldi in SGA index Rangescan 10,000 10,000 Y 10,000 Table Access by RewiD 100,000 7,000,000 =1,000,000 110,000 1,010,000 <-1,010,000 FuTabeScan 1,000,000 1,000,000 N musmblookread.count TABLE 1. Blockr reads andi memory Usage for large table access methods fora a 10 percent scan ofa very larget table.
